Release 10.1A: OpenEdge Development:
Progress Dynamics Repository Reference

gst_password_history table — gstph

This table keeps a history of passwords used previously by users. It is used for audit purposes and to prevent users from choosing the same password within a specified time period.

Table 16–7 lists the table’s FLA, fields, and foreign keys.

Table 16–7: gst_password_history table information 

Table FLA	Fields (data type)	Foreign keys
gstph	password_history_obj (Decimal) user_obj (Decimal) old_password (Character) password_change_date (Date) password_change_time (Integer) changed_by_user_obj (Decimal)	user_obj

Table 16–8 gives details of the table’s indexes.

Table 16–8: gst_password_history index information 

Index name	Elements	Type
XPKgst_password_history	password_history_obj	Primary Unique
XAK1gst_password_history	user_obj old_password password_change_date password_change_time	Unique
XIE1gst_password_history	user_obj password_change_date password_change_time	Nonunique